"192.168.0.1:sipop" Previous topic Chapter index Next topic

Functions

 

UDF

Entry Point

Library Name

Input params

Returns

Description

ABS

IB_UDF_abs

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

ACOS

IB_UDF_acos

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

ADDDAY

addDay

fbudf

TIMESTAMP

TIMESTAMP BY REFERENCE

 

ADDHOUR

addHour

fbudf

TIMESTAMP

TIMESTAMP BY REFERENCE

 

ADDMILLISECOND

addMilliSecond

fbudf

TIMESTAMP

TIMESTAMP BY REFERENCE

 

ADDMINUTE

addMinute

fbudf

TIMESTAMP

TIMESTAMP BY REFERENCE

 

ADDMONTH

addMonth

fbudf

TIMESTAMP

TIMESTAMP BY REFERENCE

 

ADDSECOND

addSecond

fbudf

TIMESTAMP

TIMESTAMP BY REFERENCE

 

ADDWEEK

addWeek

fbudf

TIMESTAMP

TIMESTAMP BY REFERENCE

 

ADDYEAR

addYear

fbudf

TIMESTAMP

TIMESTAMP BY REFERENCE

 

ASCII_CHAR

IB_UDF_ascii_char

ib_udf

CSTRING (1)

CSTRING (1) BY REFERENCE (FREE_IT)

 

ASCII_VAL

IB_UDF_ascii_val

ib_udf

INTEGER

INTEGER BY VALUE

 

ASIN

IB_UDF_asin

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

ATAN

IB_UDF_atan

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

ATAN2

IB_UDF_atan2

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

BIN_AND

IB_UDF_bin_and

ib_udf

INTEGER

INTEGER BY VALUE

 

BIN_OR

IB_UDF_bin_or

ib_udf

INTEGER

INTEGER BY VALUE

 

BIN_XOR

IB_UDF_bin_xor

ib_udf

INTEGER

INTEGER BY VALUE

 

CEILING

IB_UDF_ceiling

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

COS

IB_UDF_cos

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

COSH

IB_UDF_cosh

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

COT

IB_UDF_cot

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

DIV

IB_UDF_div

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

DNULLIF

dNullIf

fbudf

DOUBLE PRECISION

DOUBLE PRECISION BY REFERENCE

 

DNVL

idNvl

fbudf

DOUBLE PRECISION

DOUBLE PRECISION BY REFERENCE

 

DOW

DOW

fbudf

VARCHAR (15)

VARCHAR (15) BY REFERENCE

 

DPOWER

power

fbudf

DOUBLE PRECISION

DOUBLE PRECISION BY REFERENCE

 

FLOOR

IB_UDF_floor

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

GETEXACTTIMESTAMP

getExactTimestamp

fbudf

TIMESTAMP

TIMESTAMP BY REFERENCE

 

I64NULLIF

iNullIf

fbudf

NUMERIC (18, 4)

NUMERIC (18, 4) BY REFERENCE

 

I64NVL

idNvl

fbudf

NUMERIC (18, 0)

NUMERIC (18, 0) BY REFERENCE

 

I64ROUND

fbround

fbudf

NUMERIC (18, 4)

NUMERIC (18, 4) BY REFERENCE

 

I64TRUNCATE

fbtruncate

fbudf

NUMERIC (18, 0)

NUMERIC (18, 0) BY REFERENCE

 

INULLIF

iNullIf

fbudf

INTEGER

INTEGER BY REFERENCE

 

INVL

idNvl

fbudf

INTEGER

INTEGER BY REFERENCE

 

LN

IB_UDF_ln

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

LOG

IB_UDF_log

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

LOG10

IB_UDF_log10

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

LOWER

IB_UDF_lower

ib_udf

CSTRING (255)

CSTRING (255) BY REFERENCE (FREE_IT)

 

LPAD

IB_UDF_lpad

ib_udf

CSTRING (255)

CSTRING (255) BY REFERENCE (FREE_IT)

 

LTRIM

IB_UDF_ltrim

ib_udf

CSTRING (255)

CSTRING (255) BY REFERENCE (FREE_IT)

 

MOD

IB_UDF_mod

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

PI

IB_UDF_pi

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

RAND

IB_UDF_rand

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

ROUND

fbround

fbudf

INTEGER

INTEGER BY REFERENCE

 

RPAD

IB_UDF_rpad

ib_udf

CSTRING (255)

CSTRING (255) BY REFERENCE (FREE_IT)

 

RTRIM

IB_UDF_rtrim

ib_udf

CSTRING (255)

CSTRING (255) BY REFERENCE (FREE_IT)

 

SDOW

SDOW

fbudf

VARCHAR (5)

VARCHAR (5) BY REFERENCE

 

SIGN

IB_UDF_sign

ib_udf

INTEGER

INTEGER BY VALUE

 

SIN

IB_UDF_sin

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

SINH

IB_UDF_sinh

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

SNULLIF

sNullIf

fbudf

VARCHAR (100)

VARCHAR (100) BY REFERENCE

 

SNVL

sNvl

fbudf

VARCHAR (100)

VARCHAR (100) BY REFERENCE

 

SQRT

IB_UDF_sqrt

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

SRIGHT

right

fbudf

VARCHAR (100)

VARCHAR (100) BY REFERENCE

 

STRING2BLOB

string2blob

fbudf

BLOB

BLOB BY REFERENCE

 

STRLEN

IB_UDF_strlen

ib_udf

INTEGER

INTEGER BY VALUE

 

SUBSTR

IB_UDF_substr

ib_udf

CSTRING (255)

CSTRING (255) BY REFERENCE (FREE_IT)

 

SUBSTRLEN

IB_UDF_substrlen

ib_udf

CSTRING (255)

CSTRING (255) BY REFERENCE (FREE_IT)

 

TAN

IB_UDF_tan

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

TANH

IB_UDF_tanh

ib_udf

DOUBLE PRECISION

DOUBLE PRECISION BY VALUE

 

TRUNCATE

fbtruncate

fbudf

INTEGER

INTEGER BY REFERENCE

 

    This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m. Previous topic Chapter index Next topic